.. _`Create Dataset`:

.. _`com.sympathyfordata.azure.powerbi.datasets.create`:

Create Dataset
``````````````

.. image:: node_powerbi_table.svg
   :width: 48







Documentation
:::::::::::::

Create new push :ref:`powerbi_dataset` with schema from input table.

Newly created datsets will contain one table with schema
(column names and types) determined by the input table.

Duplicate dataset names are not allowed, so you must make sure to enter a
unique and unused name or select a fallback option (`When exists`) to
determine what happens if a dataset with the same name already exists.

:ref:`Propagates PowerBi input to output <powerbi_port>` with
the following changes:

    - Active dataset is set/replaced.


Definition
::::::::::


Input ports
...........

    **powerbi**  powerbi
        PowerBi

    **table**  table
        Table


Output ports
............

    **powerbi**  powerbi
        PowerBi




Configuration
.............

    **Dataset name** (dataset)
        Dataset name, it may not be empty
    **When exists** (exists)
        Action when dataset name already exists
    **Retention policy** (retention)
        Retention policy, FIFO: (first in first out) keep most recent 200,000 rows. None: Keep all rows, max 5,000,000.
    **Table name** (table)
        Table name, if not specified, dataset name will be used as table name







Examples
........

* :download:`BasicPowerBI.syx </Examples/Azure/PowerBi/BasicPowerBI.syx>`




Implementation
..............

.. automodule:: node_powerbi
    :noindex:

.. class:: CreateDatasetPowerBi
    :noindex: